SUPPORT / SAMPLES & SAS NOTES
Problem Note 54047: You cannot log on to the SAS® Financial Management Add-In for Microsoft Excel
 |  |  |  |  |
If multiple services with the same name are defined in the metadata, you might be unable to log on to the SAS Financial Management Add-In for Microsoft Excel. In this case, an error similar to the following is displayed in the SAS Add-In for Microsoft Office log:
--------------- EXCEPTION REPORT ---------------
[06.23.2014 13:07:10,296] Login failure.
[06.23.2014 13:07:10,298] System.ArgumentException: An item with the
same key has already been added.
at System.Collections.Generic.Dictionary`2.Insert(TKey key, TValue value,
Boolean add)
at SAS.FM.Common.CommonServerProvider.retrieveAllServicesFromRestServiceRegistryDoc()
at SAS.FM.Common.CommonServerProvider.initializeServicesDictionary()
at SAS.FM.Common.CommonServerProvider.authenticate(ServiceURLInformation
sui, String userId, String password, String& infoMsg)
at SAS.FM.Common.LogonDlg.retrieveLogonInformation(Boolean envSpecified,
String key, String userHost, Int32 userPort, Boolean userSecure, String
userName, String password)
at SAS.FM.Common.LogonDlg.btnOK_Click(Object sender, EventArgs e)
[06.23.2014 13:07:10,305] ----------- END OF EXCEPTION REPORT ------------If you encounter this problem, contact SAS Technical Support.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Financial Management | Microsoft® Windows® for x64 | 5.4_M1 | 5.5 | 9.4 TS1M2 | 9.4 TS1M2 |
| Microsoft Windows 8 Enterprise 32-bit | 5.4_M1 | 5.5 | 9.4 TS1M2 | 9.4 TS1M2 | ||
| Microsoft Windows 8 Enterprise x64 | 5.4_M1 | 5.5 | 9.4 TS1M2 | 9.4 TS1M2 | ||
| Microsoft Windows 8 Pro 32-bit | 5.4_M1 | 5.5 | 9.4 TS1M2 | 9.4 TS1M2 | ||
| Microsoft Windows 8 Pro x64 | 5.4_M1 | 5.5 | 9.4 TS1M2 | 9.4 TS1M2 | ||
| Microsoft Windows 8.1 Enterprise 32-bit | 5.4_M1 | 5.5 | 9.4 TS1M2 | 9.4 TS1M2 | ||
| Microsoft Windows 8.1 Enterprise x64 | 5.4_M1 | 5.5 | 9.4 TS1M2 | 9.4 TS1M2 | ||
| Microsoft Windows 8.1 Pro | 5.4_M1 | 5.5 | 9.4 TS1M2 | 9.4 TS1M2 | ||
| Microsoft Windows 8.1 Pro 32-bit | 5.4_M1 | 5.5 | 9.4 TS1M2 | 9.4 TS1M2 | ||
| Microsoft Windows Server 2008 | 5.4_M1 | 5.5 | 9.4 TS1M2 | 9.4 TS1M2 | ||
| Microsoft Windows Server 2008 R2 | 5.4_M1 | 5.5 | 9.4 TS1M2 | 9.4 TS1M2 | ||
| Microsoft Windows Server 2008 for x64 | 5.4_M1 | 5.5 | 9.4 TS1M2 | 9.4 TS1M2 | ||
| Microsoft Windows Server 2012 Datacenter | 5.4_M1 | 5.5 | 9.4 TS1M2 | 9.4 TS1M2 | ||
| Microsoft Windows Server 2012 R2 Datacenter | 5.4_M1 | 5.5 | 9.4 TS1M2 | 9.4 TS1M2 | ||
| Microsoft Windows Server 2012 R2 Std | 5.4_M1 | 5.5 | 9.4 TS1M2 | 9.4 TS1M2 | ||
| Microsoft Windows Server 2012 Std | 5.4_M1 | 5.5 | 9.4 TS1M2 | 9.4 TS1M2 | ||
| Windows 7 Enterprise 32 bit | 5.4_M1 | 5.5 | 9.4 TS1M2 | 9.4 TS1M2 | ||
| Windows 7 Enterprise x64 | 5.4_M1 | 5.5 | 9.4 TS1M2 | 9.4 TS1M2 | ||
| Windows 7 Home Premium 32 bit | 5.4_M1 | 5.5 | 9.4 TS1M2 | 9.4 TS1M2 | ||
| Windows 7 Home Premium x64 | 5.4_M1 | 5.5 | 9.4 TS1M2 | 9.4 TS1M2 | ||
| Windows 7 Professional 32 bit | 5.4_M1 | 5.5 | 9.4 TS1M2 | 9.4 TS1M2 | ||
| Windows 7 Professional x64 | 5.4_M1 | 5.5 | 9.4 TS1M2 | 9.4 TS1M2 | ||
| Windows 7 Ultimate 32 bit | 5.4_M1 | 5.5 | 9.4 TS1M2 | 9.4 TS1M2 | ||
| Windows 7 Ultimate x64 | 5.4_M1 | 5.5 | 9.4 TS1M2 | 9.4 TS1M2 | ||
| 64-bit Enabled AIX | 5.4_M1 | 5.5 | 9.4 TS1M2 | 9.4 TS1M2 | ||
| 64-bit Enabled Solaris | 5.4_M1 | 5.5 | 9.4 TS1M2 | 9.4 TS1M2 | ||
| Linux for x64 | 5.4_M1 | 5.5 | 9.4 TS1M2 | 9.4 TS1M2 | ||